In [ ]:
import sqlite3
import pandas as pd
import pygwalker as pyg

# Database file path
db_file_path = "spend_intake2.db"

# Connect to the SQLite database
conn = sqlite3.connect(db_file_path)

# SQL query
query = """
SELECT *
FROM AP_Items_for_classification
"""

# Execute the query and fetch the data into a pandas DataFrame
df = pd.read_sql_query(query, conn)

# Close the database connection
conn.close()

# Use Pygwalker to render the DataFrame
pyg.walk(df, kernel_computation=True, spec='gw_config.json', spec_io_mode="rw")
Box(children=(HTML(value='\n<div id="ifr-pyg-00061fd3fbfe0cbc8WgjJesAac7Fxvul" style="height: auto">\n    <hea…
Loading Graphic-Walker UI...
Out[ ]:
<pygwalker.api.pygwalker.PygWalker at 0x1a61777e3d0>